import { moneyFormatCol } from "@/utils";

export const columnsDataMQW = [
    {
        dataField: "PZRQ",
        caption: "凭证日期",
        width: 100,
        alignment: "left",
    },
    {
        dataField: "PZLX",
        caption: "凭证类型",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "PZBH",
        width: 100,
        caption: "编号",
        alignment: "left",
    },

    {
        dataField: "ZY",
        minWidth: 120,
        caption: "摘要",
        alignment: "left",
    },
    {
        dataField: "JFJE",
        dataType: "number",
        caption: "借方发生额",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },

    {
        dataField: "DFJE",
        // dataTypeCustom: "money-number",
        dataType: "number",
        caption: "贷方发生额",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },
    {
        dataField: "Diff",
        caption: "差异",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        dataType: "number",
        alignment: "left",
    },
    {
        dataField: "TZR",
        width: 100,
        caption: "填制人",
        alignment: "left",
    },
    {
        dataField: "JZR",
        width: 100,
        caption: "记账人",
        alignment: "left",
    },
    {
        dataField: "SHR",
        width: 100,
        caption: "审核人",
        alignment: "left",
    }
];

export const columnsDataMQW2 = [
    {
        dataField: "PZID",
        dataType: "string",
        caption: "组信息",
        width: 120,
        alignment: "center",
        groupIndex: 0,
    },
    {
        dataField: "PZRQ",
        caption: "凭证日期",
        width: 100,
        alignment: "left",
    },
    {
        dataField: "PZLX",
        caption: "凭证类型",
        width: 80,
        alignment: "left",
    },
    {
        dataField: "FLNO",
        width: 40,
        caption: "编号",
        alignment: "left",
    },

    {
        dataField: "ZY",
        minWidth: 120,
        caption: "摘要",
        alignment: "left",
    },
    {
        dataField: "KMMC",
        minWidth: 120,
        caption: "科目名称",
        alignment: "left",
    },
    {
        dataField: "JFJE",
        dataType: "number",
        caption: "借方",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },

    {
        dataField: "DFJE",
        dataType: "number",
        caption: "贷方",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },
    {
        dataField: "HSXM",
        caption: "核算项目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFKMMC",
        caption: "对方科目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "TZR",
        width: 100,
        caption: "填制人",
        alignment: "left",
    },
    {
        dataField: "JZR",
        width: 100,
        caption: "记账人",
        alignment: "left",
    },
    {
        dataField: "SHR",
        width: 100,
        caption: "审核人",
        alignment: "left",
    }
];


export const columnsDataMQW2_1 = [
    {
        dataField: "PZID",
        dataType: "string",
        caption: "组信息",
        width: 120,
        alignment: "center",
        groupIndex: 0,
    },
    {
        dataField: "PZRQ",
        caption: "凭证日期",
        width: 100,
        alignment: "left",
    },
    {
        dataField: "PZLX",
        caption: "凭证类型",
        minWidth: 80,
        alignment: "left",
    },
    {
        dataField: "FLNO",
        minWidth: 40,
        caption: "编号",
        alignment: "left",
    },

    {
        dataField: "ZY",
        minWidth: 120,
        caption: "摘要",
        alignment: "left",
    },
    {
        dataField: "KMMC",
        minWidth: 120,
        caption: "科目名称",
        alignment: "left",
    },
    {
        dataField: "JFJE",
        dataType: "number",
        caption: "借方",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },

    {
        dataField: "DFJE",
        dataType: "number",
        caption: "贷方",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },
    {
        dataField: "DJ",
        caption: "单价",
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "JFSL",
        caption: "借方数量",
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFSL",
        caption: "贷方数量",
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "HSXM",
        caption: "核算项目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFKMMC",
        caption: "对方科目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "TZR",
        width: 100,
        caption: "填制人",
        alignment: "left",
    },
    {
        dataField: "JZR",
        width: 100,
        caption: "记账人",
        alignment: "left",
    },
    {
        dataField: "SHR",
        width: 100,
        caption: "审核人",
        alignment: "left",
    }
];


export const columnsDataMQW2_2 = [
    {
        dataField: "PZID",
        dataType: "string",
        caption: "组信息",
        width: 120,
        alignment: "center",
        groupIndex: 0,
    },
    {
        dataField: "PZRQ",
        caption: "凭证日期",
        width: 100,
        alignment: "left",
    },
    {
        dataField: "PZLX",
        caption: "凭证类型",
        minWidth: 80,
        alignment: "left",
    },
    {
        dataField: "FLNO",
        width: 40,
        caption: "编号",
        alignment: "left",
    },

    {
        dataField: "ZY",
        caption: "摘要",
        minWidth: 120,
        alignment: "left",
    },
    {
        dataField: "KMMC",
        minWidth: 120,
        caption: "科目名称",
        alignment: "left",
    },
    // {
    //     dataField: "JFJE",
    //     dataType: "number",
    //     caption: "借方",
    //     width: 150,
    //     customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
    //     alignment: "right",
    // },

    // {
    //     dataField: "DFJE",
    //     dataType: "number",
    //     caption: "贷方",
    //     width: 150,
    //     customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
    //     alignment: "right",
    // },
    {
        dataField: "DJ",
        caption: "单价",
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "JFSL",
        caption: "借方数量",
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFSL",
        caption: "贷方数量",
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "Currency",
        minWidth: 120,
        caption: "币种",
        alignment: "left",
    },
    {
        dataField: "WHHL",
        minWidth: 120,
        caption: "汇率",
        dataType: "number",
        alignment: "left",
    },
    {
        dataField: "JFWB",
        caption: "借方外币",
        dataType: "number",
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFWB",
        caption: "贷方外币",
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "HSXM",
        caption: "核算项目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFKMMC",
        caption: "对方科目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "TZR",
        width: 100,
        caption: "填制人",
        alignment: "left",
    },
    {
        dataField: "JZR",
        width: 100,
        caption: "记账人",
        alignment: "left",
    },
    {
        dataField: "SHR",
        width: 100,
        caption: "审核人",
        alignment: "left",
    }
];



export const columnsDataMQW2_3 = [
    {
        dataField: "PZID",
        dataType: "string",
        caption: "组信息",
        width: 120,
        alignment: "center",
        groupIndex: 0,
    },
    {
        dataField: "PZRQ",
        caption: "凭证日期",
        width: 100,
        alignment: "left",
    },
    {
        dataField: "PZLX",
        caption: "凭证类型",
        minWidth: 80,
        alignment: "left",
    },
    {
        dataField: "FLNO",
        width: 40,
        caption: "编号",
        alignment: "left",
    },

    {
        dataField: "ZY",
        minWidth: 120,
        caption: "摘要",
        alignment: "left",
    },
    {
        dataField: "KMMC",
        minWidth: 120,
        caption: "科目名称",
        alignment: "left",
    },
    {
        dataField: "JFJE",
        dataType: "number",
        caption: "借方",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },

    {
        dataField: "DFJE",
        dataType: "number",
        caption: "贷方",
        width: 150,
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        alignment: "right",
    },
    {
        dataField: "Currency",
        minWidth: 120,
        caption: "币种",
        alignment: "left",
    },
    {
        dataField: "WHHL",
        minWidth: 120,
        caption: "汇率",
        dataType: "number",
        alignment: "left",
    },
    {
        dataField: "JFWB",
        caption: "借方外币",
        dataType: "number",
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFWB",
        caption: "贷方外币",
        customizeText: ({ value }: any) => `${moneyFormatCol(value, false)}`,
        dataType: "number",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "HSXM",
        caption: "核算项目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "DFKMMC",
        caption: "对方科目",
        width: 150,
        alignment: "left",
    },
    {
        dataField: "TZR",
        width: 100,
        caption: "填制人",
        alignment: "left",
    },
    {
        dataField: "JZR",
        width: 100,
        caption: "记账人",
        alignment: "left",
    },
    {
        dataField: "SHR",
        width: 100,
        caption: "审核人",
        alignment: "left",
    }
];


export const conditionsColumnData = [{
    keyDataString: 'PZRQ',
    conditionsName: '凭证日期',
    sqlType: 'string'
}, {
    keyDataString: 'PZLX',
    conditionsName: '凭证类型',
    sqlType: 'string'
}, {
    keyDataString: 'PZBH',
    conditionsName: '凭证编号',
    sqlType: 'string'
}, {
    keyDataString: 'PZYF',
    conditionsName: '凭证月份',
}, {
    keyDataString: 'ZY',
    conditionsName: '摘要',
    sqlType: 'string'
}, {
    keyDataString: 'KMMC',
    conditionsName: '科目名称',
    sqlType: 'string'
}, {
    keyDataString: 'KMBH',
    conditionsName: '科目编号',
    sqlType: 'string'
}, {
    keyDataString: 'DFKMMC',
    conditionsName: '对方科目',
    sqlType: 'string'
}, {
    keyDataString: 'JFJE',
    conditionsName: '借方金额',
    sqlType: 'number'
}, {
    keyDataString: 'DFJE',
    conditionsName: '贷方金额',
    sqlType: 'number'
}, {
    keyDataString: 'FSE',
    conditionsName: '发生额',
    sqlType: 'number'
}, {
    keyDataString: 'HSXM',
    conditionsName: '核算项目',
    sqlType: 'string'
}];


export const conditionStatesData = [{
    StateID: 0,
    conditionName: '等于',
    slqfh: '='
}, {
    StateID: 1,
    conditionName: '不等于',
    slqfh: '<>'
}, {
    StateID: 2,
    conditionName: '大于',
    slqfh: '>'
}, {
    StateID: 3,
    conditionName: '大于等于',
    slqfh: '>='
}, {
    StateID: 4,
    conditionName: '小于',
    slqfh: '<'
}, {
    StateID: 5,
    conditionName: '小于等于',
    slqfh: '<='
}, {
    StateID: 6,
    conditionName: '区间',
    slqfh: 'between 0 and '
}, {
    StateID: 7,
    conditionName: '包含',
    slqfh: 'like'
}, {
    StateID: 8,
    conditionName: '不包含',
    slqfh: 'not like'
}, {
    StateID: 9,
    conditionName: '左包含',
    slqfh: 'like'
}, {
    StateID: 10,
    conditionName: '右包含',
    slqfh: 'like'
}, {
    StateID: 11,
    conditionName: '空',
    slqfh: '='
}, {
    StateID: 12,
    conditionName: '不空',
    slqfh: '<>'
}, {
    StateID: 13,
    conditionName: '长度',
    slqfh: '='
}];